IGNORE THIS TOPIC- VIDEOS ARE NO LONGER SUPPORTED

To complete the Linear Model portion of the project, you will need to use technology to create a scatterplot, find the regression line, plot the regression line, and find r and r².  

Below is a short video of using Microsoft Excel for an Olympic project.  Also, see "Example of Linear Regression & Correlation" below for a more complete discussion and videos for the Linear Regression/Correlation to be used for the assigned project.  See especially "Graphical Linear Regression I & II" videos.

     Visit Scatterplot - Start (VIDEO) to see how to create a scatter plot using Microsoft Excel and format the axes.

Visit Scatterplot - Regression Line (VIDEO) to see how to add labels and title to the scatterplot, how to generate and graph the line of best fit (regression) and obtain the value of r² in Microsoft Excel.

Using Excel to obtain precise values of slope m and y-intercept b of the regression line: Video,